package com.example.manu_facturer_orders.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * @author: tobed
 * @date: 2022/9/12
 * @time: 9:27
 */
@Mapper
public interface CityMapper {

    @Select("select province from provinces where provinceid = #{id};")
    String getProvinceById(@Param("id") Integer id);

    @Select("select city from cities where cityid = #{id};")
    String getCitityById(@Param("id") Integer id);

    @Select("select area from areas where areaid = #{id};")
    String getAreaById(@Param("id") Integer id);

}
